<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" interactivePageBreakByFrame="true" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-26. 17:55:31--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 17:58:34--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 17:26:29--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 11:50:41-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1024px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles><CSS value="background-color:white"/></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1400px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin on Thin - Risk Management</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Usable</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Thin on Thin Trending">
			<contents><textItem><dataSource><dataItemValue refDataItem="Lastest Usable"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>VMDK Provisioned</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Thin on Thin Trending">
			<contents><textItem><dataSource><dataItemValue refDataItem="Lastest VMDK Provisioned"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Used</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Thin on Thin Trending">
			<contents><textItem><dataSource><dataItemValue refDataItem="Lastest Used"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Used %</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Thin on Thin Trending">
			<contents><textItem><dataSource><dataItemValue refDataItem="% Used"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin on Thin Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="Thin on Thin List in TB">
			<contents><textItem><dataSource><dataItemValue refDataItem="Sum of Thin Capacity"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin on Thin %</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Thin on Thin List in TB">
			<contents><textItem><dataSource><dataItemValue refDataItem="Sum of Thin %"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:450px;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Thin on Thin Summary</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Device)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;margin-top:10px"/></style><tableRows><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="Device Summary">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;font-family:Arial;font-size:12px;color:#333333"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-size:11px;color:#454545;font-family:Arial;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Device"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-size:11px;color:#454545;font-family:Arial;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Metric"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List2" refQuery="Capacity Summary">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-size:11px;color:#454545;font-family:Arial;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-size:11px;color:#454545;font-family:Arial;border-bottom:1px dotted #E1E1E2"/><dataFormat><numberFormat pattern="###,###,### TB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Metric"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:10px;padding-left:10px;vertical-align:top;width:100%;height:100%"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														</contents><style><CSS value="height:5px;vertical-align:top;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:450px;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Risk Management</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Top Allocated Thin Pools)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List4" refQuery="Thin on Thin Percent">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-size:11px;color:#454545;font-family:Arial;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat><CSS value="font-size:11px;color:#454545;font-family:Arial;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin on Thin Percent (%)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Thin on Thin Percent (%)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:450px;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>(Top Used Thin on Thin Pools)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List3" refQuery="Percent Used Summary">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;font-family:Arial;font-size:12px;color:#333333;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-size:11px;color:#454545;font-family:Arial;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-size:11px;color:#454545;font-family:Arial;border-bottom:1px dotted #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Physical Used (%)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Physical Used (%)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Historical Thin on Thin Allocation</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Usable vs Provisioned)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Thin on Thin Trending">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Physical Usable (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="VMDK Provisioned (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:450px;height:230px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Historical Thin on Thin Allocation</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Used vs Provisioned)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														
											<v2_combinationChart maxHotspots="10000" name="Combination Chart8" refQuery="Thin on Thin Trending">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Physical Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="VMDK Provisioned (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:450px;height:220px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Thin on Thin Details</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List5" refQuery="Thin on Thin List in TB" rowsPerPage="10000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#454545;text-align:right;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Array Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:11px;color:#454545;text-align:right;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Array Name"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Array Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#454545;text-align:right;border-bottom:1px solid #E1E1E2;border-left:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:11px;color:#454545;text-align:right;border-bottom:1px dotted #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#454545;text-align:right;border-bottom:1px solid #E1E1E2;border-left:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Physical Usable"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:11px;color:#454545;text-align:right;border-bottom:1px dotted #E1E1E2"/><dataFormat><numberFormat pattern="###,###,###,### TB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Physical Usable"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#454545;text-align:right;border-bottom:1px solid #E1E1E2;border-left:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Physical Used"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:11px;color:#454545;text-align:right;border-bottom:1px dotted #E1E1E2"/><dataFormat><numberFormat pattern="###,###,###,### TB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Physical Used"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#454545;text-align:right;border-bottom:1px solid #E1E1E2;border-left:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Physical Used (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:11px;color:#454545;text-align:right;border-bottom:1px dotted #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Physical Used (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#454545;text-align:right;border-bottom:1px solid #E1E1E2;border-left:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Thin on Thin Capacity"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:11px;color:#454545;text-align:right;border-bottom:1px dotted #E1E1E2"/><dataFormat><numberFormat pattern="###,###,###,### TB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin on Thin Capacity"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#454545;text-align:right;border-bottom:1px solid #E1E1E2;border-left:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Thin on Thin Percent (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:11px;color:#454545;text-align:right;border-bottom:1px dotted #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin on Thin Percent (%)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Array Name"/></listGroups></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>6.4 Thin on Thin Risk Management</reportName><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="if"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="is"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="os"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle></classStyles><queries><query name="Device Summary">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2" type="passThrough">
			<sqlText>SELECT
	'ESX Servers' AS 'Device',
	COUNT(dwh_inventory.host.id) AS 'Metric'
FROM
	dwh_inventory.hv_server
JOIN
	dwh_inventory.host
ON
	dwh_inventory.hv_server.hostId = dwh_inventory.host.id
AND
	dwh_inventory.host.active = 1
UNION
SELECT
	'Virtual Machines' AS 'Device',
	COUNT(dwh_inventory.hv_virtual_machine.id) AS 'Metric'
FROM
	dwh_inventory.hv_virtual_machine
UNION
SELECT
	'Virtual Disks' AS 'Device',
	COUNT(dwh_inventory.hv_virtual_disk.id) AS 'Metric'
FROM
	dwh_inventory.hv_virtual_machine_to_disk
JOIN
	dwh_inventory.hv_virtual_disk
ON
	dwh_inventory.hv_virtual_machine_to_disk.virtualDiskId = dwh_inventory.hv_virtual_disk.id
UNION
SELECT
	'Datastores' AS 'Device',
	COUNT(DISTINCT dwh_inventory.hv_data_store.id) AS 'Metric'
FROM
	dwh_inventory.hv_data_store
UNION
SELECT
	'Associated Arrays' AS 'Device',
	COUNT(DISTINCT dwh_inventory.storage.id) AS 'Metric'
FROM
	dwh_inventory.storage
WHERE
	dwh_inventory.storage.active = 1
AND
	dwh_inventory.storage.id IN (SELECT DISTINCT dwh_inventory.hv_data_store_to_internal_volume.storageId FROM dwh_inventory.hv_data_store_to_internal_volume) 
OR
	dwh_inventory.storage.id IN (SELECT DISTINCT dwh_inventory.hv_data_store_to_volume.storageId FROM dwh_inventory.hv_data_store_to_volume)
UNION
SELECT
	'Associated Pools' AS 'Device',
	COUNT(DISTINCT x.poolId) AS 'Metric'
FROM
	(
	SELECT 	DISTINCT dwh_inventory.storage_pool.id poolId
	FROM
		dwh_inventory.hv_data_store_to_internal_volume
	JOIN
		dwh_inventory.internal_volume
	ON
		dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId = dwh_inventory.internal_volume.id
	JOIN
		dwh_inventory.storage_pool
	ON
		dwh_inventory.internal_volume.storagePoolId = dwh_inventory.storage_pool.id
	AND
		dwh_inventory.storage_pool.thinProvisioningSupported = 1
	UNION
	SELECT 	DISTINCT dwh_inventory.storage_pool.id poolId
	FROM
		dwh_inventory.hv_data_store
	JOIN 	dwh_inventory.hv_data_store_to_volume
	ON 	dwh_inventory.hv_data_store.id = dwh_inventory.hv_data_store_to_volume.dataStoreId
	JOIN 	dwh_inventory.volume
	ON 	dwh_inventory.hv_data_store_to_volume.volumeId = dwh_inventory.volume.id
	JOIN 	dwh_capacity.volume_dimension
	ON 	dwh_inventory.volume.id = dwh_capacity.volume_dimension.id
	JOIN 	dwh_capacity.volume_capacity_fact
	ON 	dwh_capacity.volume_dimension.tk = dwh_capacity.volume_capacity_fact.volumeTk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_inventory.storage_pool
	ON 	dwh_capacity.storage_pool_dimension.id = dwh_inventory.storage_pool.id	WHERE
		dwh_inventory.storage_pool.id NOT IN (
				SELECT 	dwh_inventory.storage_pool.id poolId
				FROM
					dwh_inventory.hv_data_store_to_internal_volume
				JOIN
					dwh_inventory.internal_volume
				ON
					dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId = dwh_inventory.internal_volume.id
				JOIN
					dwh_inventory.storage_pool
				ON
					dwh_inventory.internal_volume.storagePoolId = dwh_inventory.storage_pool.id
				GROUP BY
					dwh_inventory.storage_pool.id	)
	AND
		dwh_inventory.storage_pool.thinProvisioningSupported = 1
	) X
UNION
SELECT
	'Associated NAS Volumes' AS 'Device',
	COUNT(DISTINCT dwh_inventory.internal_volume.id) AS 'Metric'
FROM
	dwh_inventory.internal_volume
WHERE
	dwh_inventory.internal_volume.id IN (SELECT DISTINCT dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId FROM dwh_inventory.hv_data_store_to_internal_volume)
UNION
SELECT
	'Associated SAN Volumes' AS 'Device',
	COUNT(DISTINCT dwh_inventory.volume.id) AS 'Metric'
FROM
	dwh_inventory.volume
WHERE
	dwh_inventory.volume.id IN (SELECT DISTINCT dwh_inventory.hv_data_store_to_volume.volumeId FROM dwh_inventory.hv_data_store_to_volume)</sqlText>
		<mdProjectedItems><mdProjectedItem name="Device"/><mdProjectedItem name="Metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Device"><expression>[SQL2].[Device]</expression></dataItem><dataItem name="Metric"><expression>[SQL2].[Metric]</expression></dataItem></selection>
		</query><query name="Capacity Summary">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1" type="passThrough">
			<sqlText>SELECT
	'Virtual Machine Capacity' AS 'Capacity',
	ROUND(SUM(dwh_inventory.hv_virtual_machine.provisionedCapacityMB)/1024/1024, 0) AS 'Metric'
FROM
	dwh_inventory.hv_virtual_machine
UNION
SELECT
	'Virtual Disk Capacity' AS 'Device',
	ROUND(SUM(dwh_inventory.hv_virtual_disk.capacityMB)/1024/1024, 0) AS 'Metric'
FROM
	dwh_inventory.hv_virtual_machine_to_disk
JOIN
	dwh_inventory.hv_virtual_disk
ON
	dwh_inventory.hv_virtual_machine_to_disk.virtualDiskId = dwh_inventory.hv_virtual_disk.id
UNION
SELECT
	'Datastore Capacity' AS 'Device',
	ROUND(SUM(dwh_inventory.hv_data_store.capacityMB)/1024/1024, 0) AS 'Metric'
FROM
	dwh_inventory.hv_data_store
UNION
SELECT
	'Datastore Provisioned' AS 'Device',
	ROUND(SUM(x.dsGB/1024), 0) AS 'Metric'
FROM
	(
		SELECT 	dwh_inventory.storage_pool.id poolId,
			dwh_inventory.volume.id volId,
			dwh_inventory.volume.capacityMB/1024 AS volGB,
			SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
			ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.volume.capacityMB, 4) AS provPercent
		FROM 	dwh_inventory.hv_data_store
		JOIN 	dwh_inventory.hv_data_store_to_volume
		ON 	dwh_inventory.hv_data_store.id = dwh_inventory.hv_data_store_to_volume.dataStoreId
		JOIN 	dwh_inventory.volume
		ON 	dwh_inventory.hv_data_store_to_volume.volumeId = dwh_inventory.volume.id
		JOIN 	dwh_capacity.volume_dimension
		ON 	dwh_inventory.volume.id = dwh_capacity.volume_dimension.id
		JOIN 	dwh_capacity.volume_capacity_fact
		ON 	dwh_capacity.volume_dimension.tk = dwh_capacity.volume_capacity_fact.volumeTk
		JOIN 	dwh_capacity.storage_pool_dimension
		ON 	dwh_capacity.volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
		JOIN 	dwh_inventory.storage_pool
		ON 	dwh_capacity.storage_pool_dimension.id = dwh_inventory.storage_pool.id	WHERE
			dwh_inventory.storage_pool.id NOT IN (
					SELECT 	dwh_inventory.storage_pool.id poolId
					FROM
						dwh_inventory.hv_data_store_to_internal_volume
					JOIN
						dwh_inventory.internal_volume
					ON
						dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId = dwh_inventory.internal_volume.id
					JOIN
						dwh_inventory.storage_pool
					ON
						dwh_inventory.internal_volume.storagePoolId = dwh_inventory.storage_pool.id
					GROUP BY
						dwh_inventory.storage_pool.id	)
		AND 	dwh_inventory.storage_pool.thinProvisioningSupported = 1
		GROUP BY
			dwh_inventory.volume.id
		UNION
		SELECT 	dwh_inventory.storage_pool.id poolId,
			dwh_inventory.internal_volume.id volId,
			dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 AS volGB,
			SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
			ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.internal_volume.totalAllocatedCapacityMB, 4) AS provPercent
		FROM 	dwh_inventory.storage_pool
		JOIN 	dwh_inventory.internal_volume
		ON 	dwh_inventory.storage_pool.id = dwh_inventory.internal_volume.storagePoolId
		JOIN 	dwh_inventory.hv_data_store_to_internal_volume
		ON 	dwh_inventory.internal_volume.id = dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId
		JOIN 	dwh_inventory.hv_data_store
		ON 	dwh_inventory.hv_data_store_to_internal_volume.dataStoreId = dwh_inventory.hv_data_store.id
		GROUP BY
			dwh_inventory.internal_volume.id
	) X
UNION
SELECT
	'Physical Usable Capacity' AS 'Device',
	ROUND(SUM(x.capMB)/1024/1024, 0) AS 'Metric'
FROM
	(
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.storage_pool.totalAllocatedCapacityMB capMB
	FROM
		dwh_inventory.hv_data_store_to_internal_volume
	JOIN
		dwh_inventory.internal_volume
	ON
		dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId = dwh_inventory.internal_volume.id
	JOIN
		dwh_inventory.storage_pool
	ON
		dwh_inventory.internal_volume.storagePoolId = dwh_inventory.storage_pool.id
	AND
		dwh_inventory.storage_pool.thinProvisioningSupported = 1
	GROUP BY
		dwh_inventory.storage_pool.id
	UNION
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.storage_pool.totalAllocatedCapacityMB capMB
	FROM
		dwh_inventory.hv_data_store
	JOIN 	dwh_inventory.hv_data_store_to_volume
	ON 	dwh_inventory.hv_data_store.id = dwh_inventory.hv_data_store_to_volume.dataStoreId
	JOIN 	dwh_inventory.volume
	ON 	dwh_inventory.hv_data_store_to_volume.volumeId = dwh_inventory.volume.id
	JOIN 	dwh_capacity.volume_dimension
	ON 	dwh_inventory.volume.id = dwh_capacity.volume_dimension.id
	JOIN 	dwh_capacity.volume_capacity_fact
	ON 	dwh_capacity.volume_dimension.tk = dwh_capacity.volume_capacity_fact.volumeTk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_inventory.storage_pool
	ON 	dwh_capacity.storage_pool_dimension.id = dwh_inventory.storage_pool.id	WHERE
		dwh_inventory.storage_pool.id NOT IN (
				SELECT 	dwh_inventory.storage_pool.id poolId
				FROM
					dwh_inventory.hv_data_store_to_internal_volume
				JOIN
					dwh_inventory.internal_volume
				ON
					dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId = dwh_inventory.internal_volume.id
				JOIN
					dwh_inventory.storage_pool
				ON
					dwh_inventory.internal_volume.storagePoolId = dwh_inventory.storage_pool.id
				GROUP BY
					dwh_inventory.storage_pool.id	)
	AND
		dwh_inventory.storage_pool.thinProvisioningSupported = 1
	GROUP BY
		dwh_inventory.storage_pool.id
	) X
UNION
SELECT
	'Associated NAS Volumes' AS 'Device',
	ROUND(SUM(dwh_inventory.internal_volume.totalAllocatedCapacityMB)/1024/1024, 0) AS 'Metric'
FROM
	dwh_inventory.internal_volume
WHERE
	dwh_inventory.internal_volume.id IN (SELECT DISTINCT dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId FROM dwh_inventory.hv_data_store_to_internal_volume)
UNION
SELECT
	'Associated SAN Volumes' AS 'Device',
	ROUND(SUM(dwh_inventory.volume.capacityMB)/1024/1024, 0) AS 'Metric'
FROM
	dwh_inventory.volume
WHERE
	dwh_inventory.volume.id IN (SELECT DISTINCT dwh_inventory.hv_data_store_to_volume.volumeId FROM dwh_inventory.hv_data_store_to_volume)</sqlText>
		<mdProjectedItems><mdProjectedItem name="Capacity"/><mdProjectedItem name="Metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Capacity"><expression>[SQL1].[Capacity]</expression></dataItem><dataItem name="Metric"><expression>[SQL1].[Metric]</expression></dataItem></selection>
		</query><query name="Percent Used Summary">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL3" type="passThrough">
			<sqlText>SELECT 	CONCAT(dwh_inventory.storage.name, ' - ', dwh_inventory.storage_pool.name) AS 'Pool Name',
	ROUND(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024, 2) AS 'Physical Usable',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/1024, 2) AS 'Physical Used',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/dwh_inventory.storage_pool.totalAllocatedCapacityMB, 4) AS 'Physical Used (%)',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/dwh_inventory.storage_pool.totalAllocatedCapacityMB, 4) AS percentUsed,
	ROUND(SUM(x.dsGB), 2) AS 'Thin on Thin',
	ROUND(SUM(x.dsGB)/(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024), 4) AS thinPercent
FROM 	dwh_inventory.storage_pool
JOIN 	dwh_inventory.storage
ON 	dwh_inventory.storage_pool.storageId = dwh_inventory.storage.id
JOIN 	(
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.volume.id volId,
		dwh_inventory.volume.capacityMB/1024 AS volGB,
		SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
		ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.volume.capacityMB, 4) AS provPercent
	FROM 	dwh_inventory.hv_data_store
	JOIN 	dwh_inventory.hv_data_store_to_volume
	ON 	dwh_inventory.hv_data_store.id = dwh_inventory.hv_data_store_to_volume.dataStoreId
	JOIN 	dwh_inventory.volume
	ON 	dwh_inventory.hv_data_store_to_volume.volumeId = dwh_inventory.volume.id
	JOIN 	dwh_capacity.volume_dimension
	ON 	dwh_inventory.volume.id = dwh_capacity.volume_dimension.id
	JOIN 	dwh_capacity.volume_capacity_fact
	ON 	dwh_capacity.volume_dimension.tk = dwh_capacity.volume_capacity_fact.volumeTk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_inventory.storage_pool
	ON 	dwh_capacity.storage_pool_dimension.id = dwh_inventory.storage_pool.id
	AND	dwh_inventory.storage_pool.thinProvisioningSupported = 1
	GROUP BY
		dwh_inventory.volume.id
	UNION
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.internal_volume.id volId,
		dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 AS volGB,
		SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
		ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.internal_volume.totalAllocatedCapacityMB, 4) AS provPercent
	FROM 	dwh_inventory.storage_pool
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_inventory.storage_pool.id = dwh_inventory.internal_volume.storagePoolId
	AND	dwh_inventory.storage_pool.thinProvisioningSupported = 1
	JOIN 	dwh_inventory.hv_data_store_to_internal_volume
	ON 	dwh_inventory.internal_volume.id = dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId
	JOIN 	dwh_inventory.hv_data_store
	ON 	dwh_inventory.hv_data_store_to_internal_volume.dataStoreId = dwh_inventory.hv_data_store.id
	GROUP BY
		dwh_inventory.internal_volume.id
	) X
ON 	dwh_inventory.storage_pool.id = x.poolId
GROUP BY
	dwh_inventory.storage_pool.id
ORDER BY
	percentUsed DESC 
LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Physical Usable"/><mdProjectedItem name="Physical Used"/><mdProjectedItem name="Physical Used (%)"/><mdProjectedItem name="percentUsed"/><mdProjectedItem name="Thin on Thin"/><mdProjectedItem name="thinPercent"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Pool Name"><expression>[SQL3].[Pool Name]</expression></dataItem><dataItem name="Physical Usable"><expression>[SQL3].[Physical Usable]</expression></dataItem><dataItem name="Physical Used"><expression>[SQL3].[Physical Used]</expression></dataItem><dataItem name="Physical Used (%)"><expression>[SQL3].[Physical Used (%)]</expression></dataItem></selection>
		</query><query name="Thin on Thin Percent">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL4" type="passThrough">
			<sqlText>SELECT 	CONCAT(dwh_inventory.storage.name, ' - ', dwh_inventory.storage_pool.name) AS 'Pool Name',
	ROUND(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024, 2) 'Physical Usable',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/1024, 2) AS 'Physical Used',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/dwh_inventory.storage_pool.totalAllocatedCapacityMB, 4) AS 'Physical Used (%)',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/dwh_inventory.storage_pool.totalAllocatedCapacityMB, 4) AS percentUsed,
	ROUND(SUM(x.dsGB), 2) AS 'Thin on Thin',
	ROUND(SUM(x.dsGB)/(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024), 4) AS 'Thin on Thin Percent (%)',
	ROUND(SUM(x.dsGB)/(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024), 4) AS thinPercent
FROM 	dwh_inventory.storage_pool
JOIN 	dwh_inventory.storage
ON 	dwh_inventory.storage_pool.storageId = dwh_inventory.storage.id
JOIN 	(
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.volume.id volId,
		dwh_inventory.volume.capacityMB/1024 AS volGB,
		SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
		ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.volume.capacityMB, 4) AS provPercent
	FROM 	dwh_inventory.hv_data_store
	JOIN 	dwh_inventory.hv_data_store_to_volume
	ON 	dwh_inventory.hv_data_store.id = dwh_inventory.hv_data_store_to_volume.dataStoreId
	JOIN 	dwh_inventory.volume
	ON 	dwh_inventory.hv_data_store_to_volume.volumeId = dwh_inventory.volume.id
	JOIN 	dwh_capacity.volume_dimension
	ON 	dwh_inventory.volume.id = dwh_capacity.volume_dimension.id
	JOIN 	dwh_capacity.volume_capacity_fact
	ON 	dwh_capacity.volume_dimension.tk = dwh_capacity.volume_capacity_fact.volumeTk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_inventory.storage_pool
	ON 	dwh_capacity.storage_pool_dimension.id = dwh_inventory.storage_pool.id
	AND 	dwh_inventory.storage_pool.thinProvisioningSupported = 1
	WHERE
		dwh_inventory.storage_pool.id NOT IN (
				SELECT 	dwh_inventory.storage_pool.id poolId
				FROM 	dwh_inventory.hv_data_store_to_internal_volume
				JOIN 	dwh_inventory.internal_volume
				ON 	dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId = dwh_inventory.internal_volume.id
				JOIN 	dwh_inventory.storage_pool
				ON 	dwh_inventory.internal_volume.storagePoolId = dwh_inventory.storage_pool.id
				GROUP BY
					dwh_inventory.storage_pool.id)
	GROUP BY
		dwh_inventory.volume.id
	UNION
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.internal_volume.id volId,
		dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 AS volGB,
		SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
		ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.internal_volume.totalAllocatedCapacityMB, 4) AS provPercent
	FROM 	dwh_inventory.storage_pool
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_inventory.storage_pool.id = dwh_inventory.internal_volume.storagePoolId
	AND 	dwh_inventory.storage_pool.thinProvisioningSupported = 1
	JOIN 	dwh_inventory.hv_data_store_to_internal_volume
	ON 	dwh_inventory.internal_volume.id = dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId
	JOIN 	dwh_inventory.hv_data_store
	ON 	dwh_inventory.hv_data_store_to_internal_volume.dataStoreId = dwh_inventory.hv_data_store.id
	GROUP BY
		dwh_inventory.internal_volume.id
	) X
ON 	dwh_inventory.storage_pool.id = x.poolId
GROUP BY
	dwh_inventory.storage_pool.id

ORDER BY
	thinPercent DESC
LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Physical Usable"/><mdProjectedItem name="Physical Used"/><mdProjectedItem name="Physical Used (%)"/><mdProjectedItem name="percentUsed"/><mdProjectedItem name="Thin on Thin"/><mdProjectedItem name="Thin on Thin Percent (%)"/><mdProjectedItem name="thinPercent"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Pool Name"><expression>[SQL4].[Pool Name]</expression></dataItem><dataItem name="Physical Usable"><expression>[SQL4].[Physical Usable]</expression></dataItem><dataItem name="Thin on Thin"><expression>[SQL4].[Thin on Thin]</expression></dataItem><dataItem name="Thin on Thin Percent (%)"><expression>[SQL4].[Thin on Thin Percent (%)]</expression></dataItem><dataItem name="Thin on Thin TB"><expression>[Thin on Thin]/1024</expression></dataItem></selection>
		</query><query name="Thin on Thin List">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL5" type="passThrough">
			<sqlText>SELECT 	dwh_inventory.storage.name AS 'Array Name',
	dwh_inventory.storage_pool.name AS 'Pool Name',
	ROUND(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024, 2) 'Physical Usable',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/1024, 2) AS 'Physical Used',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/dwh_inventory.storage_pool.totalAllocatedCapacityMB, 4) AS 'Physical Used (%)',
	ROUND(SUM(x.dsGB), 2) AS 'Thin on Thin Capacity',
	ROUND(SUM(x.dsGB)/(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024), 4) AS 'Thin on Thin Percent (%)'
FROM 	dwh_inventory.storage_pool
JOIN 	dwh_inventory.storage
ON 	dwh_inventory.storage_pool.storageId = dwh_inventory.storage.id
JOIN 	(
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.volume.id volId,
		dwh_inventory.volume.capacityMB/1024 AS volGB,
		SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
		ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.volume.capacityMB, 4) AS provPercent
	FROM 	dwh_inventory.hv_data_store
	JOIN 	dwh_inventory.hv_data_store_to_volume
	ON 	dwh_inventory.hv_data_store.id = dwh_inventory.hv_data_store_to_volume.dataStoreId
	JOIN 	dwh_inventory.volume
	ON 	dwh_inventory.hv_data_store_to_volume.volumeId = dwh_inventory.volume.id
	JOIN 	dwh_capacity.volume_dimension
	ON 	dwh_inventory.volume.id = dwh_capacity.volume_dimension.id
	JOIN 	dwh_capacity.volume_capacity_fact
	ON 	dwh_capacity.volume_dimension.tk = dwh_capacity.volume_capacity_fact.volumeTk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_inventory.storage_pool
	ON 	dwh_capacity.storage_pool_dimension.id = dwh_inventory.storage_pool.id
	AND 	dwh_inventory.storage_pool.thinProvisioningSupported = 1
	WHERE
		dwh_inventory.storage_pool.id NOT IN (
				SELECT 	dwh_inventory.storage_pool.id poolId
				FROM 	dwh_inventory.hv_data_store_to_internal_volume
				JOIN 	dwh_inventory.internal_volume
				ON 	dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId = dwh_inventory.internal_volume.id
				JOIN 	dwh_inventory.storage_pool
				ON 	dwh_inventory.internal_volume.storagePoolId = dwh_inventory.storage_pool.id
				GROUP BY
					dwh_inventory.storage_pool.id)
	GROUP BY
		dwh_inventory.volume.id
	UNION
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.internal_volume.id volId,
		dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 AS volGB,
		SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024 AS dsGB,
		ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.internal_volume.totalAllocatedCapacityMB, 4) AS provPercent
	FROM 	dwh_inventory.storage_pool
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_inventory.storage_pool.id = dwh_inventory.internal_volume.storagePoolId
	AND 	dwh_inventory.storage_pool.thinProvisioningSupported = 1
	JOIN 	dwh_inventory.hv_data_store_to_internal_volume
	ON 	dwh_inventory.internal_volume.id = dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId
	JOIN 	dwh_inventory.hv_data_store
	ON 	dwh_inventory.hv_data_store_to_internal_volume.dataStoreId = dwh_inventory.hv_data_store.id
	GROUP BY
		dwh_inventory.internal_volume.id
	) X
ON 	dwh_inventory.storage_pool.id = x.poolId
GROUP BY
	dwh_inventory.storage_pool.id
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Physical Usable"/><mdProjectedItem name="Physical Used"/><mdProjectedItem name="Physical Used (%)"/><mdProjectedItem name="Thin on Thin Capacity"/><mdProjectedItem name="Thin on Thin Percent (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Array Name"><expression>[SQL5].[Array Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL5].[Pool Name]</expression></dataItem><dataItem name="Physical Usable"><expression>[SQL5].[Physical Usable]</expression></dataItem><dataItem name="Physical Used"><expression>[SQL5].[Physical Used]</expression></dataItem><dataItem name="Physical Used (%)"><expression>[SQL5].[Physical Used (%)]</expression></dataItem><dataItem name="Thin on Thin Capacity"><expression>[SQL5].[Thin on Thin Capacity]</expression></dataItem><dataItem name="Thin on Thin Percent (%)"><expression>[SQL5].[Thin on Thin Percent (%)]</expression></dataItem></selection>
		</query><query name="Thin on Thin Trending">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL6" type="passThrough">
			<sqlText>SELECT 	physical.fullDate AS 'Full Date',
	ROUND(SUM(physical.capacityTB),0) AS 'Physical Usable (TB)',
	ROUND(SUM(physical.usedTB),0) AS 'Physical Used (TB)',
	ROUND(SUM(Xvirtual.capacityTB),0) AS 'VMDK Provisioned (TB)'
FROM
	(
	SELECT 	dwh_capacity.storage_dimension.tk storageTk,
		dwh_capacity.date_dimension.fullDate fullDate,
		dwh_capacity.date_dimension.tk dateTk,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024 capacityTB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024 usedTB
	FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
	JOIN 	dwh_capacity.storage_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	AND 	dwh_capacity.storage_pool_dimension.thinProvisioningSupported = 1
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
	GROUP BY
		dwh_capacity.storage_dimension.tk,
		dwh_capacity.date_dimension.tk
	) physical
JOIN
	(
	SELECT 	dwh_capacity.storage_dimension.tk storageTk,
		dwh_capacity.date_dimension.tk dateTk,
		SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024 capacityTB
	FROM 	dwh_capacity.vm_capacity_fact
	JOIN 	dwh_capacity.storage_dimension
	ON 	dwh_capacity.vm_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
	GROUP BY
		dwh_capacity.storage_dimension.tk,
		dwh_capacity.date_dimension.tk
	) Xvirtual
ON 	physical.storageTk = Xvirtual.storageTk
AND 	physical.dateTk = Xvirtual.dateTk
GROUP BY
	physical.dateTk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Full Date"/><mdProjectedItem name="Physical Usable (TB)"/><mdProjectedItem name="Physical Used (TB)"/><mdProjectedItem name="VMDK Provisioned (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Full Date"><expression>[SQL6].[Full Date]</expression></dataItem><dataItem aggregate="total" name="Physical Usable (TB)"><expression>[SQL6].[Physical Usable (TB)]</expression></dataItem><dataItem aggregate="total" name="Physical Used (TB)"><expression>[SQL6].[Physical Used (TB)]</expression></dataItem><dataItem aggregate="total" name="VMDK Provisioned (TB)"><expression>[SQL6].[VMDK Provisioned (TB)]</expression></dataItem><dataItem name="Max Date"><expression>maximum([Full Date] for report)</expression></dataItem><dataItem name="Lastest VMDK Provisioned" aggregate="total"><expression>IF([Full Date]=[Max Date]) THEN ([VMDK Provisioned (TB)]) ELSE (0)</expression></dataItem><dataItem name="Lastest Usable" aggregate="total"><expression>IF([Full Date]=[Max Date]) THEN ([Physical Usable (TB)]) ELSE (0)</expression></dataItem><dataItem name="Lastest Used" aggregate="total"><expression>IF([Full Date]=[Max Date]) THEN ([Physical Used (TB)]) ELSE (0)</expression></dataItem><dataItem name="% Used"><expression>[Lastest Used]/[Lastest Usable]</expression></dataItem></selection>
		</query><query name="Query1">
			<source>
				<model/>
			</source>
			<selection/>
		</query><query name="Thin on Thin List in TB">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 	dwh_inventory.storage.name AS 'Array Name',
	dwh_inventory.storage_pool.name AS 'Pool Name',
	ROUND(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024/1024, 2) 'Physical Usable',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/1024/1024, 2) AS 'Physical Used',
	ROUND(dwh_inventory.storage_pool.totalUsedCapacityMB/dwh_inventory.storage_pool.totalAllocatedCapacityMB, 4) AS 'Physical Used (%)',
	ROUND(SUM(x.dsGB), 2) AS 'Thin on Thin Capacity',
	ROUND(SUM(x.dsGB)/(dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024/1024), 4) AS 'Thin on Thin Percent (%)'
FROM 	dwh_inventory.storage_pool
JOIN 	dwh_inventory.storage
ON 	dwh_inventory.storage_pool.storageId = dwh_inventory.storage.id
JOIN 	(
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.volume.id volId,
		dwh_inventory.volume.capacityMB/1024/1024 AS volGB,
		SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024/1024 AS dsGB,
		ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.volume.capacityMB, 4) AS provPercent
	FROM 	dwh_inventory.hv_data_store
	JOIN 	dwh_inventory.hv_data_store_to_volume
	ON 	dwh_inventory.hv_data_store.id = dwh_inventory.hv_data_store_to_volume.dataStoreId
	JOIN 	dwh_inventory.volume
	ON 	dwh_inventory.hv_data_store_to_volume.volumeId = dwh_inventory.volume.id
	JOIN 	dwh_capacity.volume_dimension
	ON 	dwh_inventory.volume.id = dwh_capacity.volume_dimension.id
	JOIN 	dwh_capacity.volume_capacity_fact
	ON 	dwh_capacity.volume_dimension.tk = dwh_capacity.volume_capacity_fact.volumeTk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_inventory.storage_pool
	ON 	dwh_capacity.storage_pool_dimension.id = dwh_inventory.storage_pool.id
	AND 	dwh_inventory.storage_pool.thinProvisioningSupported = 1
	WHERE
		dwh_inventory.storage_pool.id NOT IN (
				SELECT 	dwh_inventory.storage_pool.id poolId
				FROM 	dwh_inventory.hv_data_store_to_internal_volume
				JOIN 	dwh_inventory.internal_volume
				ON 	dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId = dwh_inventory.internal_volume.id
				JOIN 	dwh_inventory.storage_pool
				ON 	dwh_inventory.internal_volume.storagePoolId = dwh_inventory.storage_pool.id
				GROUP BY
					dwh_inventory.storage_pool.id)
	GROUP BY
		dwh_inventory.volume.id
	UNION
	SELECT 	dwh_inventory.storage_pool.id poolId,
		dwh_inventory.internal_volume.id volId,
		dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024/1024 AS volGB,
		SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/1024/1024 AS dsGB,
		ROUND(SUM(dwh_inventory.hv_data_store.provisionedCapacityMB)/dwh_inventory.internal_volume.totalAllocatedCapacityMB, 4) AS provPercent
	FROM 	dwh_inventory.storage_pool
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_inventory.storage_pool.id = dwh_inventory.internal_volume.storagePoolId
	AND 	dwh_inventory.storage_pool.thinProvisioningSupported = 1
	JOIN 	dwh_inventory.hv_data_store_to_internal_volume
	ON 	dwh_inventory.internal_volume.id = dwh_inventory.hv_data_store_to_internal_volume.internalVolumeId
	JOIN 	dwh_inventory.hv_data_store
	ON 	dwh_inventory.hv_data_store_to_internal_volume.dataStoreId = dwh_inventory.hv_data_store.id
	GROUP BY
		dwh_inventory.internal_volume.id
	) X
ON 	dwh_inventory.storage_pool.id = x.poolId
GROUP BY
	dwh_inventory.storage_pool.id
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Physical Usable"/><mdProjectedItem name="Physical Used"/><mdProjectedItem name="Physical Used (%)"/><mdProjectedItem name="Thin on Thin Capacity"/><mdProjectedItem name="Thin on Thin Percent (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Array Name"><expression>[SQL7].[Array Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL7].[Pool Name]</expression></dataItem><dataItem name="Physical Usable"><expression>[SQL7].[Physical Usable]</expression></dataItem><dataItem name="Physical Used"><expression>[SQL7].[Physical Used]</expression></dataItem><dataItem name="Physical Used (%)"><expression>[SQL7].[Physical Used (%)]</expression></dataItem><dataItem name="Thin on Thin Capacity"><expression>[SQL7].[Thin on Thin Capacity]</expression></dataItem><dataItem name="Thin on Thin Percent (%)"><expression>[SQL7].[Thin on Thin Percent (%)]</expression></dataItem><dataItem name="Sum of Thin Capacity" aggregate="total"><expression>total([Thin on Thin Capacity] for report)</expression></dataItem><dataItem name="Sum of Usable"><expression>total([Physical Usable] for report)</expression></dataItem><dataItem name="Sum of Thin %" aggregate="total"><expression>[Sum of Thin Capacity]/[Sum of Usable]</expression></dataItem></selection>
		</query></queries></report>